﻿CREATE TABLE [dbo].[FinanceMonthTable] (
    [id]                 INT             IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
    [CompanyId]          INT             CONSTRAINT [DF_FinanceMonthTable_CompanyId_1] DEFAULT ((0)) NULL,
    [CompanyName]        NVARCHAR (100)  CONSTRAINT [DF_FinanceMonthTable_CompanyName_1] DEFAULT ('') NULL,
    [MAid]               INT             CONSTRAINT [DF_FinanceMonthTable_MAid] DEFAULT ((0)) NULL,
    [MAname]             NVARCHAR (100)  CONSTRAINT [DF_FinanceMonthTable_MAname_1] DEFAULT ('') NULL,
    [bd]                 INT             CONSTRAINT [DF_FinanceMonthTable_bd_1] DEFAULT ((0)) NULL,
    [bd_je]              DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_bd_je] DEFAULT ((0)) NULL,
    [wz]                 INT             CONSTRAINT [DF_FinanceMonthTable_wz_1] DEFAULT ((0)) NULL,
    [wz_je]              DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_wz_je] DEFAULT ((0)) NULL,
    [tz]                 INT             CONSTRAINT [DF_FinanceMonthTable_tz_1] DEFAULT ((0)) NULL,
    [qyQQ]               INT             CONSTRAINT [DF_FinanceMonthTable_qyQQ_1] DEFAULT ((0)) NULL,
    [qyQQ_je]            DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_qyQQ_je] DEFAULT ((0)) NULL,
    [albb]               INT             CONSTRAINT [DF_FinanceMonthTable_albb] DEFAULT ((0)) NULL,
    [qt]                 INT             CONSTRAINT [DF_FinanceMonthTable_qt_1] DEFAULT ((0)) NULL,
    [qt_je]              DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_IDC_je1] DEFAULT ((0)) NULL,
    [IDC]                INT             CONSTRAINT [DF_FinanceMonthTable_IDC] DEFAULT ((0)) NULL,
    [IDC_je]             DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_IDC_je] DEFAULT ((0)) NULL,
    [xfml]               DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_xfml_1] DEFAULT ((0)) NULL,
    [xsml]               DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_xsml_1] DEFAULT ((0)) NULL,
    [xse]                DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_xse_1] DEFAULT ((0)) NULL,
    [xzxse]              DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_xzxse] DEFAULT ((0)) NULL,
    [xfxse]              DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_xfxse] DEFAULT ((0)) NULL,
    [mlhj]               DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_mlhj_1] DEFAULT ((0)) NULL,
    [xzys]               DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_xzys_1] DEFAULT ((0)) NULL,
    [wksr]               DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_wksr_1] DEFAULT ((0)) NULL,
    [tx]                 DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_tx_1] DEFAULT ((0)) NULL,
    [rcfy]               DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_rcfy_1] DEFAULT ((0)) NULL,
    [dhkdf]              DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_dhkdf] DEFAULT ((0)) NULL,
    [sdf]                DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_sdf] DEFAULT ((0)) NULL,
    [bgfy]               DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_bgfy] DEFAULT ((0)) NULL,
    [clf]                DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_clf] DEFAULT ((0)) NULL,
    [zdf]                DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_zdf] DEFAULT ((0)) NULL,
    [cwfy]               DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_cwfy] DEFAULT ((0)) NULL,
    [zppxf]              DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_zppxf] DEFAULT ((0)) NULL,
    [scxcf]              DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_scxcf] DEFAULT ((0)) NULL,
    [yggz]               DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_yggz] DEFAULT ((0)) NULL,
    [ygbx]               DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_ygbx] DEFAULT ((0)) NULL,
    [sf]                 DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_sf] DEFAULT ((0)) NULL,
    [ff]                 DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_ff] DEFAULT ((0)) NULL,
    [zbfy]               DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_zbfy] DEFAULT ((0)) NULL,
    [ygfl]               DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_ygfl] DEFAULT ((0)) NULL,
    [sjglf]              DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_sjglf] DEFAULT ((0)) NULL,
    [qtzc]               DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_qtzc] DEFAULT ((0)) NULL,
    [fyze]               DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_fyze] DEFAULT ((0)) NULL,
    [fyyxsr]             DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_fyyxsr] DEFAULT ((0)) NULL,
    [jkzc]               DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_jkzc] DEFAULT ((0)) NULL,
    [jksr]               DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_jksr] DEFAULT ((0)) NULL,
    [dkzc]               DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_dkzc] DEFAULT ((0)) NULL,
    [dksr]               DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_dksr] DEFAULT ((0)) NULL,
    [tzzc]               DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_tzzc] DEFAULT ((0)) NULL,
    [tzsr]               DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_tzsr] DEFAULT ((0)) NULL,
    [fh]                 DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_fh] DEFAULT ((0)) NULL,
    [ssclwsr]            DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_qtsr] DEFAULT ((0)) NULL,
    [ssclwzc]            DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_ssclwzc] DEFAULT ((0)) NULL,
    [cl]                 DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_cl_1] DEFAULT ((0)) NULL,
    [sscl]               DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_sscl_1] DEFAULT ((0)) NULL,
    [zxf]                DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_zxf_1] DEFAULT ((0)) NULL,
    [gdzc]               DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_gdzc_1] DEFAULT ((0)) NULL,
    [jj]                 DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_jjbcfk] DEFAULT ((0)) NULL,
    [bcfk]               DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_bcfk] DEFAULT ((0)) NULL,
    [kqfk]               DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_kqfk] DEFAULT ((0)) NULL,
    [qqqdfqzcxse]        DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_qqqdfqzcxse] DEFAULT ((0)) NULL,
    [qqqdfqzcml]         DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_fqzc] DEFAULT ((0)) NULL,
    [qqqd]               DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_qqqd] DEFAULT ((0)) NULL,
    [bdztc]              INT             CONSTRAINT [DF_FinanceMonthTable_bdztc] DEFAULT ((0)) NULL,
    [bdztcxse]           DECIMAL (18, 2) CONSTRAINT [DF_FinanceMonthTable_bdztcxse] DEFAULT ((0)) NULL,
    [createdate]         DATETIME        CONSTRAINT [DF_FinanceMonthTable_createdate_1] DEFAULT (getdate()) NULL,
    [userid]             VARCHAR (10)    CONSTRAINT [DF_FinanceMonthTable_userid_1] DEFAULT ('') NULL,
    [username]           NVARCHAR (50)   CONSTRAINT [DF_FinanceMonthTable_username_1] DEFAULT ('') NULL,
    [TMonth]             VARCHAR (10)    CONSTRAINT [DF_FinanceMonthTable_TMonth_1] DEFAULT ('') NULL,
    [QYQQ_CustomerCount] INT             NULL,
    CONSTRAINT [PK_FinanceMonthTable] PRIMARY KEY CLUSTERED ([id] ASC)
);


GO
CREATE NONCLUSTERED INDEX [IX_FinanceMonthTable]
    ON [dbo].[FinanceMonthTable]([MAid] ASC);


GO
CREATE NONCLUSTERED INDEX [IX_FinanceMonthTable_1]
    ON [dbo].[FinanceMonthTable]([CompanyId] ASC);


GO
CREATE NONCLUSTERED INDEX [IX_FinanceMonthTable_2]
    ON [dbo].[FinanceMonthTable]([TMonth] ASC);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'管理区ID', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'MAid';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'管理区名称', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'MAname';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'百度数', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'bd';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'网站数', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'wz';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'通址', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'tz';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'企业QQ', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'qyQQ';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'阿里巴巴', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'albb';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'其他数', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'qt';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'其他产品销售额', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'qt_je';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'IDC产品单数', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'IDC';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'IDC产品销售额', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'IDC_je';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'续费毛利', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'xfml';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'销售毛利', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'xsml';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'销售额', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'xse';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'新增销售额', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'xzxse';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'续费销售额', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'xfxse';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'毛利合计', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'mlhj';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'新增应收', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'xzys';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'尾款收入', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'wksr';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'摊销', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'tx';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'日常费用', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'rcfy';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'电话宽带费', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'dhkdf';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'水电费', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'sdf';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'办公费用', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'bgfy';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'差旅费', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'clf';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'招待费', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'zdf';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'财务费用', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'cwfy';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'招聘培训费', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'zppxf';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'市场宣传费', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'scxcf';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'员工工资', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'yggz';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'税费', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'sf';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'房费', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'ff';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'总办费用', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'zbfy';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'员工福利', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'ygfl';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'上缴管理费', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'sjglf';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'其他支出', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'qtzc';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'费用总额', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'fyze';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'非营业性收入', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'fyyxsr';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'借款支出', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'jkzc';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'借款收入', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'jksr';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'调款支出', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'dkzc';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'调款收入', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'dksr';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'投资支出', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'tzzc';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'投资收入', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'tzsr';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'分红', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'fh';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'实收纯利外收入', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'ssclwsr';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'实收纯利外支出', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'ssclwzc';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'纯利', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'cl';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'实收纯利', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'sscl';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'固定资产支出(176)及装修费(159)', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'zxf';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'固定资产', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'gdzc';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'奖金补偿返款', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'jj';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'非企支出', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'qqqdfqzcml';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'QQ渠道', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'qqqd';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'创建日期', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'createdate';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'录入人编号', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'userid';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'录入人姓名', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'username';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'月报月份', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FinanceMonthTable', @level2type = N'COLUMN', @level2name = N'TMonth';

